package db;

import java.sql.SQLException;
import java.util.ArrayList;

import model.Project;
import model.ProjectSubContractor;
import model.SubContractor;

public interface IFProjectSubContractor
	{
		public int addProjectSubContractor(Project project, SubContractor sub, double price) throws SQLException;
		public int deleteProjectSubContractor(Project project, int subID) throws SQLException;
		public int updateProjectSubContractor(Project project, int subID, double price) throws SQLException;

		public ArrayList<ProjectSubContractor> getAllProjectSubContractor(Project project) throws SQLException;

		public double getTotalProjectSubContractorPrice(int projectID) throws SQLException;
	}
